Education and Services Hub

Course Title:

Course ID:

270524 0601 1845ESH

Course Dates :

27/May/2024

 To

31/May/2024

Course Duration :

5

Course Location:

London

United Kingdom

Course Fees GBP £ :

Primary Price

£4,555.99

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$5,829.09

VAT may vary depending on the country where the course or workshop is held

Course Category:

Computer Science Programmes

MS Excel, Soft Skills

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

The MS Excel Intermediate Course is designed to equip participants with the necessary skills to proficiently navigate and utilize Microsoft Excel beyond basic functions.
This comprehensive program delves into intermediate-level features and techniques, empowering attendees to enhance their productivity, efficiency, and analytical capabilities within Excel.
Each day of the course will combine theoretical concepts with practical hands-on exercises to ensure participants gain a comprehensive understanding of intermediate Excel functionalities.

Objectives

• Provide an in-depth understanding of intermediate Excel functions and tools.
• Enhance participants' ability to organize, analyse, and visualize data effectively.
• Equip attendees with advanced formatting techniques for professional-looking spreadsheets.
• Enable participants to automate tasks and streamline workflows using Excel.
• Foster the development of problem-solving skills through hands-on exercises and real-world scenarios.

Who Should Attend?

This course is ideal for individuals who have a basic understanding of Excel and seek to expand their proficiency to an intermediate level. Professionals across various industries, including analysts, managers, administrators, and students, will benefit from this training.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Excel Data Management and Analysis
• Review of Basic Functions and Formulas
• Sorting and Filtering Data
• Using Conditional Formatting
• Introduction to PivotTables

Day 2:
Advanced Functions and Formulas
• Logical Functions (IF, AND, OR)
• Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Text Functions (CONCATENATE, LEFT, RIGHT, MID)
• Date and Time Functions (TODAY, NOW, DATE, TIME)

Day 3:
Data Visualization and Charts
• Creating and Formatting Charts (Bar, Line, Pie, Scatter)
• Adding Trendlines and Error Bars
• Customizing Chart Elements
• Introduction to Sparklines

Day 4:
Data Analysis Tools
• Introduction to Pivot Charts
• Performing Data Analysis with What-If Analysis
• Using Goal Seek and Scenario Manager
• Data Validation and Validation Rules

Day 5:
Automation and Collaboration
• Introduction to Macros
• Recording and Running Macros
• Managing Macro Security
• Collaboration Features (Sharing Workbooks, Track Changes)

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.